SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514186 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514186 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620983,451830,401836,569319,681305,858253,230237,887832,40352,1034009,562300,1007787,930379,977252,56985,1021531,57525,418450,732322,10300,40829,224440,826658,938340,979535,904987,610181,941593,107561,45369,69849,229375,1013830,553832,839001,241263,756652,969634,501562,124948,203374,783720,765463,889319,578886,1032743,943994,804322,994954,370951,222980,597449,667206,334323,747694,428341,775433,800750,962523,503591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]