SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502866 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502866 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953252,411102,240589,570375,466508,983535,848542,579006,770555,812260,847547,64860,994173,841868,390880,23197,100389,205896,998376,951378,293328,432673,943907,317270,576552,449965,884939,414403,23931,162884,774957,119571,270601,972839,857095,637997,800901,902807,340727,483535,625281,339989,475259,870267,320691,1009951,253926,764729,67127,919253,726734,235407,725641,473296,53074,131947,384128,300940,147152,335543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502866 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502866 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]