SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002324 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002324 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011017,338336,584622,450720,561572,770611,346426,258926,1010475,1034748,321728,789443,112469,635647,1032368,690710,248547,367421,409499,540350,1019655,549038,366455,891805,299188,616295,461031,176571,967552,1045618,61327,557234,983833,905716,803038,582433,888583,522859,809172,923467,262902,78678,676343,910503,454020,593911,934928,692716,570360,145881,929262,145431,912797,641636,7231,914637,938358,187994,735723,685030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]