SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105924 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105924 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104745,1014805,185588,876476,619956,956692,355495,118939,240049,970757,811129,775432,216618,622945,947107,419856,633918,598618,381938,146844,1041860,880399,46563,377106,614442,71956,464588,206740,896633,858942,458413,723184,71691,770491,695462,497992,165475,112433,842789,562928,250540,154243,198665,288955,510174,800029,227938,835838,412626,684467,1023109,904152,1042703,607830,100963,679380,569927,680224,499661,54684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000911s ]