SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529679 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529679 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169152,889652,554250,765747,176916,49157,842400,370183,773799,149439,405292,30275,415000,362915,79633,686863,353310,878382,562740,209882,658902,592923,630977,510190,309342,238154,898989,721689,21659,544036,991363,146263,898460,278597,173973,875700,585046,208048,534567,101276,270648,465749,188194,316342,459685,814562,203499,803837,540726,518117,9353,882321,203418,11280,956275,809670,1013869,725484,871057,716836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]