SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501583 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501583 [ RunTime:0.003802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435456,385589,688670,319130,277417,144194,417068,230757,111699,267274,966868,200581,622184,24222,555106,281838,640388,172451,354976,82469,482697,815171,1021055,664882,891167,1000342,240356,980859,673825,841496,610475,644138,438296,478168,477258,585433,800971,703112,129774,22990,244659,328010,569943,1001912,425456,708618,389570,328188,402180,506504,487655,578289,461652,587358,337904,108259,1005139,465829,493888,714010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]