SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418504 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418504 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024328,213066,583006,49766,361054,879433,12299,72406,49116,245190,53706,361944,170053,808486,674189,805426,1018829,669359,670451,1021681,127584,748509,952218,483349,304448,526418,170589,100541,18960,744967,617260,487132,56255,664472,753113,828055,962797,447380,326298,158821,93043,83237,727785,1031143,479555,898626,636372,410666,458233,765635,768947,411922,1037582,20769,879053,869787,866347,1045583,126905,738259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001985s ]