SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 771041 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 771041 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478735,195451,847262,1016986,754378,677482,590854,409550,535632,759571,416198,5388,870668,863746,627350,305224,301495,270556,870837,636968,515112,1043692,300032,153461,387189,964458,924000,622734,415717,782673,4725,726863,650803,817575,495344,660032,628599,389430,647685,994312,399498,831855,626395,417462,56647,291151,615125,384342,306079,624551,1000091,173582,673569,247273,483707,342475,12787,1047925,542244,184291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 771041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 771041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]