SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510398 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510398 [ RunTime:0.002936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036806,854335,384872,547283,204993,606496,235301,571496,70595,245821,607007,864025,538988,732386,822791,746322,188368,361926,1031159,810020,53768,359399,558880,561364,237170,771977,325618,502491,213827,55116,268959,615652,392564,521986,808076,878522,211734,1017815,33194,740619,320485,287531,936668,271747,95711,873679,98953,821057,270437,924837,494325,535927,285330,39427,454579,891641,38657,701084,999284,563123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]