SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502643 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502643 [ RunTime:0.003162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364293,508203,563307,463765,700380,599944,867931,140192,301988,898793,193678,105232,992159,967844,541839,287395,75583,838885,1014336,594281,641814,399313,958883,1009633,661113,413535,771241,716347,463927,745597,185628,850554,1043309,128909,648089,16734,823494,351849,260591,64201,979465,548935,964027,741349,647581,739964,773830,983249,128967,307559,502029,300802,888246,850301,393630,1048025,809753,897654,737708,686003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]