SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020487 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020487 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412008,985155,518859,367708,206272,96762,967126,941605,1048727,819086,702394,645090,246917,658236,589976,235476,127394,594510,987964,1012968,349643,927389,247476,1001767,607297,191493,432472,311205,202556,893776,497434,889368,367142,393362,815053,487296,779843,323305,984025,533069,163987,282796,550752,333511,807856,780724,638627,263911,831123,880859,475230,644023,634755,88145,277138,8024,531811,106611,719360,859000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002342s ]