SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441521 LIMIT 1 [ RunTime:0.001158s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441521 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682421,787388,42227,244433,499804,984509,193616,146091,201965,636933,851568,563879,638001,80100,237137,893161,152890,198155,949793,548297,312443,117222,417398,489369,1047761,1041551,634351,710126,923500,729137,906686,909567,13339,864749,499285,191895,385061,507209,310098,1035877,320357,347131,481403,734290,271449,495659,337923,824241,948072,848545,35205,410352,407342,9580,616488,626609,804851,53304,8599,1024890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]