SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553713 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553713 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204742,778953,37959,356659,77350,151110,41319,64523,342716,137546,904656,138072,267421,845459,912530,773941,362430,913931,60510,466563,580927,939514,96591,47772,498691,904492,300644,842181,316210,449476,923298,857223,241556,140203,750686,461150,598216,502727,857246,199666,411097,500402,162975,787898,984226,750206,768499,19021,446268,813318,152668,224186,38576,392829,618779,101229,357043,647338,614365,973892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]