SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781148 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781148 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152075,43130,482833,957259,1008383,930148,823222,836274,545587,897254,1000298,439371,121569,413741,855679,691953,464545,423812,774115,145805,545558,447918,200838,849821,153753,115311,622586,475982,950463,894012,863484,691257,268968,972577,503743,995801,133000,823831,393425,101929,710066,287665,412574,1040868,210090,833751,521428,641726,306707,314559,1028189,117184,192923,360816,654341,24454,398686,390342,579597,435327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]