SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917691 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917691 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119069,1026346,1021488,931554,338355,215484,982121,148150,436207,666439,892209,189709,31879,543142,95704,1024179,438094,937414,325701,847143,270843,389163,916621,719868,833005,1041984,789384,1043712,319569,621202,1015165,843287,811816,898981,220053,774136,901972,413765,313363,367454,262606,625630,447317,579851,715366,446434,687055,659549,131629,347933,349757,390924,943601,1038329,82264,502475,941398,241003,392951,445837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]