SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802790 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802790 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439843,828861,783790,663377,567827,291611,120402,235592,843744,814269,707743,989482,390055,490803,147189,284914,498137,970884,853972,197418,996542,596160,317676,164647,928619,586300,659126,379856,961706,58313,629596,216096,723400,844768,876833,215330,288601,959830,604332,1035258,867853,671676,674374,975457,51920,106720,636854,522335,497536,479535,864282,425419,302814,862485,830850,61953,935972,335583,369523,214867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]