SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205498 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205498 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670111,261778,224057,685209,224580,179081,265613,1010172,749779,960999,262918,505018,657988,263340,735133,470714,596319,892687,784841,100086,48831,259514,712990,1041984,420348,57781,294329,1037416,811981,833235,254195,400019,916865,1020414,581873,1045818,1048654,593384,702101,80956,639736,106467,831442,20748,942429,771859,243616,103537,127805,830907,753311,298279,685547,67526,863769,681947,951334,1010974,588653,377568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]