SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514805 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514805 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369527,577484,978672,101030,82270,628037,158881,152814,82258,30093,634245,824864,383551,571472,521322,538811,874933,558614,422442,714222,365526,54850,315644,976694,454319,63894,678979,347357,772030,177502,852790,618910,233490,1036301,81785,47432,358477,643388,361157,403740,477569,111293,1027781,790046,597379,800336,550264,721079,130513,506849,702383,489246,431660,617763,102220,390878,952228,266426,564291,1023268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]