SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544310 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544310 [ RunTime:0.005988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144325,700385,1041521,621638,448719,81491,571874,337664,32507,660046,892542,28502,649512,919751,124762,611945,305377,814022,1033295,679358,566140,981693,153109,1018227,281407,979805,524818,929821,815736,374123,449106,964752,394231,225895,673153,462068,325803,310945,947612,583654,213449,282642,516774,105845,141675,499854,177344,806412,867389,572821,1024239,102203,1008507,449659,741775,582983,620685,540706,928450,492431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001695s ]