SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486502 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486502 [ RunTime:0.004102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651368,503515,166879,776050,424551,1043830,459355,371437,345139,608298,183294,939882,930480,354835,87251,256156,479884,867070,1035841,280281,409771,150567,31930,316986,792610,291524,978872,208990,331567,146418,805388,538448,567882,543598,97262,185067,120445,392480,536142,331792,83194,317893,963489,280123,974240,1026723,663830,389702,208124,972522,714767,925277,827020,691917,393142,769081,419612,1041123,23339,527271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]