SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631043 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631043 [ RunTime:0.002710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370838,362967,895332,122449,1048158,108469,670555,484941,537460,998991,791900,817459,535041,376620,10014,958349,185267,958493,303247,100421,108596,759669,596884,555802,362926,75965,585012,383768,177234,256136,807036,578237,454094,971468,334929,599113,490035,344400,546806,506520,372399,760649,900888,916108,452795,890286,103850,626913,362872,512023,986401,66285,336313,539693,690891,871357,417204,748022,240144,892820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]