SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406148 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406148 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152293,489783,94617,1044466,422106,1024499,462906,633228,831651,260132,543444,869165,622657,814364,1045504,299575,971539,1002896,175729,868608,146612,234654,660061,20228,164629,994324,950391,504262,213629,944016,576126,165561,44577,914727,242230,434694,150524,61982,781097,139644,198873,118808,530775,809562,510,896389,891454,1500,378395,590215,329740,163657,56505,447448,788519,282068,20047,132061,624753,557471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]