SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668985 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668985 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414002,307661,942460,618560,228779,310674,244532,102740,652483,408807,1025811,274917,476348,230589,310027,124020,993743,219577,387316,40306,783070,945856,632080,486412,365476,954849,928476,974128,592938,596068,593108,932642,855779,243343,233924,821475,298252,399882,190782,286858,560892,79419,337302,175221,200421,343604,432600,389087,1045076,992535,982616,310141,856704,644991,561428,56315,15534,545530,166251,265833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]