SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143050 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143050 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545589,122133,736133,471564,210182,901589,182880,963784,483799,734132,652053,381219,496501,295248,119245,669320,322988,268321,903746,858382,566826,644778,558884,422761,816162,212306,330957,967083,1013939,159628,459051,479037,902063,443394,342454,696280,645245,218148,278548,956518,543281,856727,1029885,347552,10380,82931,300115,743840,651361,63777,699281,274266,405762,328784,971141,859103,59718,779638,114410,6664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]