SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018120 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018120 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023166,1005457,699233,541458,1000156,800323,519864,1017066,429062,744628,171463,679608,10294,1006932,747792,53251,904608,971638,963746,50270,415633,266444,503606,307640,867317,641994,882298,699441,630841,770093,722351,471920,875839,580727,260454,947995,417169,1023333,103007,453599,509309,831720,614352,461199,276905,557262,525053,783985,932801,786330,758330,589225,352712,482226,239006,504634,1007820,986136,235330,159345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]