SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400712 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400712 [ RunTime:0.003832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292561,495912,22071,59046,168758,404982,974630,756550,577786,241163,636863,1030378,38720,748218,645994,93331,630585,432091,112072,476641,825602,447438,590019,789489,561733,1035385,415482,92662,711098,599440,99324,460302,1017999,839037,338747,244809,211747,362888,1027282,994511,610148,130336,144409,666832,719377,1004724,723221,286255,268228,208817,75252,246256,301190,371534,93652,541988,116899,405095,621770,177155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]