SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439741 LIMIT 1 [ RunTime:0.001664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439741 [ RunTime:0.004784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287407,166306,140327,152054,740659,806598,546152,28772,750103,785996,968860,524237,351734,667226,134525,87578,380661,465173,999481,656817,243155,261750,173347,290553,987366,283533,547511,791462,813440,335148,508973,440920,206772,997536,766231,331731,298776,570990,227208,112597,917230,578521,512406,693600,293285,98895,143516,1044492,891131,811103,256193,369410,769488,966390,660283,659733,839477,992181,835529,616692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]