SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410067 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410067 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615515,65439,446660,217297,647926,1042990,878322,444412,485505,1041954,154816,520392,703776,339625,1012262,918234,274069,834442,525614,293579,420833,87651,695073,199404,760814,498367,494701,811400,645764,12696,731505,397980,556788,875953,231916,618540,259692,908404,200005,191328,953675,41841,676469,700535,331508,533855,209350,757673,932270,851411,757088,837010,755210,253304,705936,918759,414859,63117,316590,344464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]