SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580856 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580856 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852462,540660,445492,27943,5004,829571,170262,798012,676442,963916,957405,244320,229243,832187,472288,147085,90109,199420,86577,281270,232011,263445,532896,321334,559861,311222,195668,487297,972792,27638,220418,938205,435076,276322,1035388,606143,487960,828369,202613,13641,388398,766315,920831,272665,968648,725782,438760,834621,478695,496511,473161,31632,515035,380761,798775,205959,258191,655482,645625,230451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002393s ]