SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478171 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478171 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381924,470756,1033328,857885,960672,875130,201065,617613,210962,183792,140400,1042567,445860,603625,601205,834953,281906,833401,101658,907140,446629,909119,270992,131471,1039285,970168,861326,362412,274462,437015,708380,486702,504354,998059,145713,607440,143832,155307,334134,315342,184902,630185,549971,388896,297880,664698,868853,162477,968197,717601,89056,712307,1012876,573728,132768,298517,471775,332085,897934,367443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]