SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419846 LIMIT 1 [ RunTime:0.001511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419846 [ RunTime:0.005028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548836,317724,129756,1027690,452416,129712,891144,546081,924382,583751,1039512,926979,795376,544111,583983,763358,618787,1028277,230435,526156,32451,250984,131193,248664,614941,791697,59948,5887,450845,727800,67943,408901,364708,835222,16082,73956,365653,652495,279226,102815,540066,967194,463863,213577,507234,1020674,728246,842312,265445,589351,366315,79824,447096,157636,440471,811951,920968,302443,31414,591285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]