SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 909118 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 909118 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927160,245728,578319,950176,490702,228482,669024,472389,417959,953251,954473,539443,302824,202094,319178,199628,252336,269669,603510,649410,114367,938934,377761,32973,410157,300112,418314,156230,65026,263114,860530,51331,343024,166148,852726,136498,546855,388429,687299,357243,704091,131120,250873,161141,141989,712003,99567,933590,126783,741059,643446,577713,281185,817844,337927,528399,88047,671224,369083,302197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 909118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 909118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]