SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473640 LIMIT 1 [ RunTime:0.001530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473640 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575978,544967,295657,820327,463991,989939,664804,293373,818136,544625,66231,892513,466525,433861,826507,100837,950641,134697,665814,898689,807524,978029,23536,710080,643593,440134,7807,243261,414066,674656,372001,386292,553590,297260,887130,52566,831504,394450,967392,985349,491285,921936,545483,892714,213578,861813,493118,787515,732079,429646,527789,1028857,1008414,56937,95731,394949,595840,397209,439062,964089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005545s ]