SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595300 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595300 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505879,295343,241371,406356,139415,163190,442111,246706,923028,801495,576847,324293,559357,719970,825365,528742,110959,363531,207958,360850,960298,48731,224517,940947,442540,304478,894058,767436,921867,869148,449622,380751,532086,638894,445390,760403,918668,923459,566272,127569,43029,225929,480870,481865,153583,333455,817258,148717,373826,53788,63756,641702,707203,773853,921195,563137,880040,511440,649840,952095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]