SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502493 LIMIT 1 [ RunTime:0.001159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502493 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272959,364522,747936,353670,141450,107092,71708,153446,349748,10787,1030964,100191,890267,385724,181583,591924,275694,691931,758845,559323,311547,512685,990624,385578,766820,722917,18263,945572,897421,269660,184136,413171,748927,949536,915094,968749,631526,586905,479042,881441,776693,963909,970883,202354,374803,969954,192673,523400,526469,433250,159291,1011345,672265,699089,931540,1009114,526046,289268,823913,529042) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.040936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002477s ]