SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129303 LIMIT 1 [ RunTime:0.001166s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129303 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034150,102966,981409,430220,369763,217782,278258,199858,468268,927865,271590,793767,870081,559270,923980,286999,568488,971474,361489,809902,352177,807990,869836,353099,347154,4108,1012886,979338,195985,103726,147275,435596,104130,826194,1018826,847575,392047,394577,529984,641516,98866,138842,972091,539836,342620,875592,297945,234918,61825,1017555,2823,500041,349019,531624,296191,199493,716888,3361,356619,795839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]