SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552609 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552609 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496929,917676,838312,177968,736119,404317,320143,398384,986962,835806,70318,1043819,537747,953895,281392,468588,866297,598076,452686,840430,708408,964564,525997,1045251,448775,244779,623685,447181,645737,796247,49568,948115,1028322,360618,756258,1048734,439930,62918,181091,432988,486933,812310,581148,186410,1018047,531233,335052,952735,918099,1036699,392263,247190,250743,1037527,611503,576958,485512,626182,655465,988101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]