SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405610 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405610 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436288,728068,544570,398430,537457,397300,614768,453444,790914,332664,611494,607856,723064,351977,968813,435268,587287,898696,307366,405229,597252,353562,249378,840624,636382,203554,48311,772204,775487,989416,281757,625012,472800,903595,891777,821352,616538,876935,290619,416649,915747,50868,929396,413919,607345,234723,263248,707371,358497,635863,500462,497537,293202,333205,882115,654173,76071,833960,775575,946799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]