SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037915 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037915 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001919,886671,532621,842992,492107,1022018,886784,316157,683691,558565,572143,544466,617637,650416,547208,796149,903905,713985,420051,1006514,921947,670018,107397,499024,838184,884996,543364,581533,413194,557230,948441,302047,727198,429969,581269,830542,419688,1000458,754664,777469,356245,1701,544797,993040,272350,196514,980374,330508,743811,854148,1002242,495008,951832,205388,597731,806452,930772,468260,819979,733305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]