SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501601 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501601 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392346,37818,808873,84734,1009401,544734,643740,950601,185318,248157,801808,987868,268557,808624,721668,582840,102044,141442,200086,1046123,689338,428401,675236,98685,526040,411723,98493,487369,17052,538086,745250,615236,760180,794819,682696,433730,708899,719692,132455,31365,788397,352506,945771,207425,830338,989362,125986,848997,721057,21045,572569,1000398,220904,315967,26713,809742,1044868,585772,60117,464546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004918s ]