SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002855s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532839 LIMIT 1 [ RunTime:0.001596s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532839 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147467,138156,19304,315718,489221,858730,642326,343919,12240,261747,309184,581497,465986,228614,325613,808115,435375,986191,407785,204113,271714,654392,895125,238370,104416,855416,257883,174301,1017744,114230,504108,511122,472213,609996,847509,32510,350814,1023836,263228,138764,645900,247547,517657,207598,13867,375569,845834,833881,983924,123603,238465,838537,443923,937104,73738,88713,512684,1014457,310848,1015444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]