SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198320 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198320 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4013,835848,775509,538415,601264,32585,389185,728241,398948,978952,1024367,778218,298361,375106,573265,884482,805936,917448,966842,1020166,808459,77898,317997,738425,705467,276255,774817,458144,1009410,345824,175543,149806,894779,879193,319361,331472,118594,94525,553931,776772,1042599,761461,47372,1022593,728070,715091,927506,167158,667893,187844,84686,1040879,997606,109100,465966,189452,975038,642873,236637,116857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]