SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534261 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534261 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573907,138254,385446,87489,219886,315753,1041433,234360,767318,177081,623301,717514,759389,634483,896738,646069,902809,189165,1001950,257032,354844,631921,746843,81087,295651,987588,320352,744861,76391,313847,663792,819012,346356,405883,932000,904493,372886,395548,570541,310057,961958,283149,488150,609598,313361,891242,683045,79593,776123,720518,640993,1020206,94591,702227,566460,265505,742640,805090,171912,430093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]