SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380181 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380181 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186406,108471,905859,1036750,463309,825154,805883,754396,760448,1019022,888422,530654,318645,207434,209799,621043,257963,975919,791112,697226,103491,200405,268087,87299,498609,989262,618267,816972,647529,140885,188037,943249,287054,138272,353339,663103,417857,162204,814977,1012805,725946,5522,128933,1033068,119763,468149,107216,301915,874139,395181,934728,945741,315950,425814,955544,310936,326984,761928,1020200,119818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]