SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401786 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401786 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66927,750891,89184,359504,903059,219976,198696,438863,307639,929453,230259,625210,724488,507300,948887,195004,177963,728620,845808,911137,420365,1043657,625021,272373,14714,926885,50260,383038,1042604,845099,996007,667118,418823,760444,1005045,499560,206334,265204,91693,459663,524375,598980,831061,861833,104569,258223,102861,710062,543015,383959,721738,422805,98773,240332,473797,516833,833347,194370,1025699,490595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002586s ]