SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489331 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489331 [ RunTime:0.003288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304207,810888,561172,746201,1031837,780082,816683,530655,112845,479336,590270,644877,926421,416446,665912,387793,256537,728343,158977,396718,195523,877287,542156,71538,834051,841574,842615,248475,1020823,320294,379887,564176,504476,435076,109913,677370,914998,907444,65519,667800,370973,65734,699061,593908,707070,448816,944044,984030,54566,234242,922312,194089,138774,177981,787596,415548,586205,732275,649017,628267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001080s ]