SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 847593 LIMIT 1 [ RunTime:0.003286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 847593 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341211,104891,394040,96094,240864,821751,8509,264948,16119,834461,803705,652534,314723,199834,884992,939437,192474,1007436,57294,326834,814551,356977,82351,539112,688975,862262,66733,573277,472672,182747,727039,1031290,111088,817182,936883,1002914,979389,90641,395342,922523,454052,419516,389336,403975,419036,126188,286157,327996,190131,344240,170683,200870,256605,221876,157269,780806,361223,735722,828452,4050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 847593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 847593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]