SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 224260 LIMIT 1 [ RunTime:0.000811s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 224260 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452870,396578,197646,134272,133370,674087,803929,411877,1005855,865564,892963,800834,460768,101964,38636,1025160,581979,774230,81738,118715,753818,394655,804085,30349,302161,326143,874299,183438,806937,927140,1024425,778414,146233,99566,796457,355437,430876,1024835,315848,698358,483828,757257,11505,422775,900074,547127,245934,362979,807556,319301,932171,369656,1020926,440234,395039,353061,616198,482729,968659,364989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 224260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 224260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]