SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543891 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543891 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131714,463650,948892,1015689,486744,164330,523024,1010250,51157,725706,409235,929717,798441,438404,478594,481086,853362,1033329,293530,499344,1035016,584498,387759,819843,757965,79381,863131,333759,794729,243143,41096,103210,351940,534409,673272,434478,695822,491359,852477,2469,920405,369870,143224,270267,312444,858791,616360,731853,185102,32196,775945,880224,293704,289104,693215,475608,344056,766734,541677,941129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]