SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020799 LIMIT 1 [ RunTime:0.001362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020799 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664062,554638,651177,1021,704029,43429,353789,209450,507661,318046,587458,942086,405381,994685,17643,368824,590239,297199,92252,587714,227159,607206,194107,636536,385835,625482,385594,403892,986179,88616,723955,560899,41167,552993,1016981,573025,741767,283379,70283,411204,436960,488847,1031869,251047,40794,879153,249043,1018250,664533,965662,962753,55184,254687,333142,284975,201190,1045867,40398,242799,974758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001729s ]