SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530820 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530820 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548630,673615,304332,324916,199721,575117,160901,1031743,832599,742999,826689,336116,70056,757840,243318,603874,10658,26084,308883,478762,6461,16221,428510,1040559,1007596,809603,893913,914377,167056,76818,813519,1006052,331622,830083,164724,1020110,515803,116295,302390,497369,405800,317324,1035818,673492,977762,952033,797644,518547,780134,221188,747070,57842,349033,847958,568817,571984,89914,560430,623549,928808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]