SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43812 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43812 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4549,958076,43285,16829,501163,228883,269434,898454,999639,51661,794026,191322,781648,375402,318347,170865,804239,1007521,166954,752192,637488,193953,97196,149524,948015,905200,41630,769126,445596,527602,945439,180644,291373,618129,12792,61594,889070,88033,91495,316282,668310,481076,278153,882145,893690,909381,238404,200334,450214,684903,555119,247628,483149,171935,783225,787475,881441,518980,561954,291259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]