SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 123813 LIMIT 1 [ RunTime:0.002469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 123813 [ RunTime:0.004967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170318,97260,1035743,379763,1034639,177236,309910,243509,441436,251981,315463,180222,122816,889128,78781,214788,887614,258327,434061,304858,796922,559256,511625,242063,511665,749076,717701,178312,230908,48810,1023025,782712,337357,982222,95803,1022091,282780,159600,177558,74861,887681,306934,832342,551216,577118,335312,692848,324554,680250,797804,485381,913026,51230,94040,706729,33245,954093,908971,852719,648527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 123813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 123813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000862s ]