SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483030 LIMIT 1 [ RunTime:0.000565s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483030 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433912,88209,594305,1045672,647807,924910,460510,621808,527446,334237,823861,181729,378782,633679,453242,616113,869901,829444,673044,663221,193771,884769,457089,397148,451305,952929,899424,103586,252840,963178,589102,73398,268997,147863,979182,750573,287249,103411,871363,388198,395926,210990,248191,285392,656948,822772,18889,482885,90367,200731,681434,782555,336789,435927,789667,521023,631251,656810,172654,200580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]