SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596450 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596450 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499547,393137,244003,470378,246841,307919,703391,996314,37632,736777,744430,1011352,945899,407698,466955,513853,623144,237060,697441,219442,99290,29067,641092,44856,188777,789814,220606,370543,939577,33727,95370,197216,216228,242814,328743,494083,171955,944143,896437,851593,525347,768136,744720,479510,788518,1037643,604897,104849,354633,395471,252828,238539,185386,959527,856369,541931,552441,352539,871140,362440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]