SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104543 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104543 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877477,576098,124057,969319,528033,528358,644038,73834,928356,989789,324903,379309,204003,440774,821530,418013,138126,578009,415347,963787,25145,484787,396743,762188,395952,762132,24571,78911,546751,659353,842061,785476,747695,719151,1022990,850798,481595,278680,832965,848703,341898,955462,874152,541404,653068,966409,473591,461605,476845,113542,457049,323713,977312,104786,953575,619164,120295,163715,472754,853172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]