SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 274583 LIMIT 1 [ RunTime:0.001216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 274583 [ RunTime:0.002709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470599,800455,662266,148242,788936,358193,998992,753084,1018804,53961,828739,466581,182987,454249,469195,607088,390800,1025878,510593,876955,924390,197553,606552,209644,750656,755882,449325,377650,551931,508919,822442,841775,21106,502614,916702,564245,355843,8441,1039498,699230,299075,333250,810616,802826,199793,950688,774079,185491,928104,245476,950868,243379,595522,955387,590639,899215,187913,282681,105633,44551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 274583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 274583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]