SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591581 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591581 [ RunTime:0.003894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378362,1002498,390010,677122,1009741,308765,571716,60543,912301,193979,480132,998258,792324,792896,484504,516576,401816,965958,474123,50271,370359,405556,383493,408275,461515,501292,144720,148784,518710,706320,27450,457050,589653,398361,286738,762922,989036,900892,11732,509522,679007,317315,17800,630293,825723,57596,1011622,718321,168772,109920,549784,476085,366184,570464,400992,623229,673438,243127,374623,537775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]