SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510991 LIMIT 1 [ RunTime:0.000898s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510991 [ RunTime:0.004308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556603,799986,876975,16347,339889,781104,1028365,60869,805810,297772,236895,317789,289953,426312,894903,128101,587193,876988,1005359,354815,137703,389154,914114,519710,271741,416993,146957,629721,774367,212361,574766,502198,468339,82639,335377,921231,98435,930331,607803,864490,397227,70695,508657,453890,386755,422547,794501,623077,439727,861809,775644,60300,422470,433250,111552,699355,674613,178224,64074,628307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.034310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001903s ]