SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469832 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469832 [ RunTime:0.003015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602984,249597,703092,388042,100409,760968,633762,474118,638381,18512,777850,500263,964909,40584,495838,43498,805802,638453,747785,85812,696825,816641,817687,617689,97737,14793,475021,445794,558770,948375,351123,669250,162593,904018,185708,81881,278542,570524,590047,206000,148177,76918,425809,690627,655230,649776,799928,574688,39794,26551,903120,959436,152642,144345,174072,479782,198564,263093,539181,212400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]