SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455554 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455554 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581559,622057,672853,595657,122816,1027333,171143,935088,863801,1013210,303742,125495,7883,705513,572412,75260,857,504298,346727,812243,76544,318234,637855,442584,616314,76297,1016797,156142,977899,913675,848577,276635,455403,660206,22621,228607,633201,972176,300342,906206,354626,43447,513353,543893,35939,909379,790825,248286,800566,48050,547333,814161,346729,123667,385043,832545,423104,289491,358458,462506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]