SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456558 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456558 [ RunTime:0.002505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873816,104546,412724,357081,581645,133775,787141,1021879,376449,509333,156879,502162,426222,390987,349111,518328,166047,19438,349334,674298,645622,490321,386472,733469,425712,447709,599514,648951,1030185,54141,624693,875292,643078,358878,553359,920302,1048247,990821,624636,131457,189335,719402,258549,806929,127913,607384,164821,428641,689219,494334,245158,1031369,275719,54088,973554,767783,493925,992068,739642,513183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004567s ]