SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991546 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991546 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510398,618768,254315,67792,862076,213914,848106,810867,668017,320479,260785,893941,1012013,656452,803831,860765,598512,154288,706164,17023,95501,1000531,664250,159917,265449,70609,866889,335284,219991,389998,1047539,182326,492199,864681,798248,866514,200938,732463,175889,852749,176085,651448,130479,222985,582351,807830,344351,553190,986652,661280,811172,129378,1043244,517347,90584,570485,133645,327247,108380,866418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]